package com.zzyl.nursing.mapper;

import java.util.List;

import com.zzyl.nursing.domain.NursingLevel;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zzyl.nursing.domain.NursingPlan;
import org.apache.ibatis.annotations.Select;

/**
 * 护理等级Mapper接口
 *
 * @author syl
 * @date 2025-05-23
 */
public interface NursingLevelMapper extends BaseMapper<NursingLevel> {

    @Select("SELECT p.id, p.plan_name, l.* FROM nursing_plan p LEFT JOIN nursing_level l ON p.id = l.lplan_id")
    List<NursingPlan> getPlan(NursingPlan nursingPlan);
}
